IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'CGO_TriviaCategory')
                    AND OBJECTPROPERTY(id, N'IsTable') = 1 ) 
  BEGIN
    DROP TABLE dbo.CGO_TriviaCategory
  END


CREATE TABLE [dbo].[CGO_TriviaCategory]
  (
    [CategoryID] [int] NOT NULL IDENTITY(1, 1),    
    [CategoryName] [nvarchar] (255) NOT NULL
  )
ON
  [PRIMARY]
GO
ALTER TABLE [dbo].[CGO_TriviaCategory] ADD CONSTRAINT [PK_CGO_TriviaCategory] PRIMARY KEY CLUSTERED  ([CategoryID]) ON [PRIMARY]
GO